Ivy Lopez-Oracle — NetSuite Community

Update your Profile with your Support type to get your Support Type badge.

Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.

Stay in the know of how NetSuite can help grow your business with our guides, webinars, and events. Subscribe Here

What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now!

No Limits. Just possibilities. Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Discover what's next at SuiteConnect Tour 2026.

Try Intelligent Payment Automation – Fee Free For Your First Month For more information, visit this thread.

New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.

Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.

Check out the Announcements page to stay updated with the latest news, updates, upcoming events, and important community information!

What if your ERP could help surface the next step before you go looking for it? Watch here to learn more!

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.

Re: Zero in a saved search drops off in the results

Ivy Lopez-Oracle

Jul 19, 2022 11:52PM

Hi @Vernita, It seems that is the standard behavior when using a Formula (Text) field and the result is a decimal number that is less than 0. I did a simple test on my account that proves this: Resul…

1
Re: Saved search with a criteria depending on the result...

Ivy Lopez-Oracle

Jul 19, 2022 4:27PM

Hi @Julien Mi Electronics, Here is a discussion I previously posted about using Summary Criteria in Saved Searches: Hope this helps. ? -Ivy

2
Re: COUNT in a saved search formula

Ivy Lopez-Oracle

Jul 7, 2022 5:11PM

Hi @OliverK, As documented in SuiteAnswers 10101: You cannot combine aggregate and non-aggregate SQL functions in the same formula definition. For example, if you create a formula using an aggregate …

1
Re: SQL Statement for combining LIKE conditions

Ivy Lopez-Oracle

Jun 21, 2022 6:15PM

Thanks for providing the exact formula, @Gabriel Jarillo Soto! @Tybrneryan, let us know if it worked for you. ?

1
Re: Item Pricing sublist on Customer dashboard

Ivy Lopez-Oracle

Jun 21, 2022 12:15AM

Hi Dirk, I tested this one on my test account and was able to reproduce the behavior that you reported. It seems that using a Pricing Saved Search on the Customer Dashboard does not filter the result…

1